﻿using System;
using System.Configuration;
using System.Collections;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Web;
using System.Data.SqlClient;//libreria para trabajar con qsl

namespace BLL
{
    public class Supervisor_Usuarios
    {
        public void cargagridview_BLL(string connstring)
            {
               //string connstring = new ConfigurationManager.ConnectionStrings["TestingConnectionString2"].ToString();
                SqlConnection sqlConnection1 = new SqlConnection(connstring);
                SqlCommand cmd = new SqlCommand();
                sqlConnection1.Open();

                cmd.CommandType = CommandType.Text;
                cmd.Connection = sqlConnection1;
                cmd.CommandText = "select top 10 * from TBL_ZMB52";

                // sqlConnection1.Open();
                SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd);
                DataSet DS_ConsultaReclamos = new DataSet();
                dataAdapter.Fill(DS_ConsultaReclamos);

                //GridView_Supervisor_Usuarios.DataSource = DS_ConsultaReclamos;
                //GridView_Supervisor_Usuarios.DataBind();

                cmd.Connection.Close();
                sqlConnection1.Close();

               


            }
    }

   }
